UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sS/0LUkuXt5+KDMIssokZ7Qj1kBMSEciZlHl8vOs2Ds='
WHERE
key_id = 'ade83342416dde15b7a7aba474557cf4a5ff30d0ec536d75eb31c4ba0f4b2086'
AND (
token = 'sS/0LUkuXt5+KDMIssokZ7Qj1kBMSEciZlHl8vOs2Ds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)