UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i9vEws8kE23vMUxH1oyVVi6q8vZYRWnFSszm0kq0mO8='
WHERE
key_id = '65c6cf91a83d88834939c5aa72281ac498389429bc780e308a9727d24a3c62f7'
AND (
token = 'i9vEws8kE23vMUxH1oyVVi6q8vZYRWnFSszm0kq0mO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)