UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ciEZALH72/+YAaW03p64qqcNQ3Ju6btLlv8BnjsGSUA='
WHERE
key_id = '3fa889cfd8d29a170ae7af8917bb5b01dd74d7f52a6eed4177f33b6d8ff707e7'
AND (
token = 'ciEZALH72/+YAaW03p64qqcNQ3Ju6btLlv8BnjsGSUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)