UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oSqWvngRIKSf02ufsTG+Xh3ZJ6a+EtLgiQ/bb1sNT00='
WHERE
key_id = 'aac248c228230596612a167801bbabeb16b58122642efd938433d38b0e1142ab'
AND (
token = 'oSqWvngRIKSf02ufsTG+Xh3ZJ6a+EtLgiQ/bb1sNT00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)