UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V0u8c7HWl90UAuRGx1TuIK7+VGmv+Q77OXVppZz96Zw='
WHERE
key_id = '1d639485f248fb9b390e028fb763e3e4fec314e604a65eabb1170bf08016d28f'
AND (
token = 'V0u8c7HWl90UAuRGx1TuIK7+VGmv+Q77OXVppZz96Zw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)