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