UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '35SBFz3ZHTeVOemVgSrNYDFWJzVlJScJ2ODYH90Mnf4='
WHERE
key_id = '7b7877f2dc196c1e529d63dfe3c20a742573f74ecafe6a0228bee9dc8f5ccc97'
AND (
token = '35SBFz3ZHTeVOemVgSrNYDFWJzVlJScJ2ODYH90Mnf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)