UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BvJrjBtrhDJSZ69J0pmbFjuzuifupJRVbxgCGgM83Hc='
WHERE
key_id = '248360f8ae3361e01b49608dcab1afd5518ef943ec2cbf0ed4d064035efca309'
AND (
token = 'BvJrjBtrhDJSZ69J0pmbFjuzuifupJRVbxgCGgM83Hc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)