UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5fYNb98MXlIWol2hHs6LhReYt5ydmV23j3hhKZcesKw='
WHERE
key_id = '4fb717672e87b8a453cb206ec444f1b26406706c07755a628ee81792194fca79'
AND (
token = '5fYNb98MXlIWol2hHs6LhReYt5ydmV23j3hhKZcesKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)