UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kFcJo6onQ87U6DcG91B2oi0vDLsq/xs2yzd9Lj97j+4='
WHERE
key_id = '1d9d7476cb56f6ece7647dd6000dad2e5cb3976babebc9f26135ed64f9025b49'
AND (
token = 'kFcJo6onQ87U6DcG91B2oi0vDLsq/xs2yzd9Lj97j+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)