UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zp8Cf54Fnu7e31F1oKImnY+zjoa3HEfxgQHyrIdUbX0='
WHERE
key_id = '186fc253f5f75091461e3e6ce4f42d282f7ed5d2304914598bc3b0a3aa2292af'
AND (
token = 'zp8Cf54Fnu7e31F1oKImnY+zjoa3HEfxgQHyrIdUbX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)