UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dfPN5oyKvGxkQrN3GsfO5PJFZVrt5xkkcA/R+ghqKyA='
WHERE
key_id = '4fe43942ea7566013f7addda4e23562c0789801c25748e901fda6de1bf2d5066'
AND (
token = 'dfPN5oyKvGxkQrN3GsfO5PJFZVrt5xkkcA/R+ghqKyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)