UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sKYHRiaqe/1OvlraY/XE29HnqSmtHCAvfcuevKNKDxg='
WHERE
key_id = 'afd2095bb9acef29c7d40a2bbdc2205df2b37c9270a011a9516594ca22c86889'
AND (
token = 'sKYHRiaqe/1OvlraY/XE29HnqSmtHCAvfcuevKNKDxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)