UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uQ0e2lcZs6IigF9LcpzIFqaN6HmzmhSBt9WA4TqugL8='
WHERE
key_id = '0b114ee1164c8ebd69a564d7dc1dedb8b432ce26a68f07955b5889da8c6abfff'
AND (
token = 'uQ0e2lcZs6IigF9LcpzIFqaN6HmzmhSBt9WA4TqugL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)