UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OLgZrmbCrSRSuV1pQmmhigfSXxrEWeWHlJKBwgvxbzc='
WHERE
key_id = '48ee4af5970dc9bff6460c1767ff613150c2d47f6f1216de3bcd8baaa6fa4ce1'
AND (
token = 'OLgZrmbCrSRSuV1pQmmhigfSXxrEWeWHlJKBwgvxbzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)