UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x6U0a7Zd6KJM254bRdt0SWtjscbD7bMUjW5tSf+Qtwk='
WHERE
key_id = 'bb05f45a0e42cf2de2103890ce64bd274acea1d6c4999f299e06f636d8158893'
AND (
token = 'x6U0a7Zd6KJM254bRdt0SWtjscbD7bMUjW5tSf+Qtwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)