UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dVEIe1GpU2F8cGKnQuOTCIfuNoBSAcn7izP2gk175vM='
WHERE
key_id = '77812e9727845a65bdcb78c1ae598109a2f1bdb74eb45974c69478be15f3fa9b'
AND (
token = 'dVEIe1GpU2F8cGKnQuOTCIfuNoBSAcn7izP2gk175vM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)