UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xwu+KQr7rV5KM85l1imFrlKjm8lfJODWd01o0Qo/jcM='
WHERE
key_id = 'a1dcd6b4239f14df19d7393bc19212098565b133d463766a8114b200ac6c5096'
AND (
token = 'Xwu+KQr7rV5KM85l1imFrlKjm8lfJODWd01o0Qo/jcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)