UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yZmpXACQr40rFo98FB3wab9y05dekTvwMgPZ3/0YaiI='
WHERE
key_id = '42e513b1a42fb6a7c5fff6d2f7ba39677371620b1877af7b66bad561074cbc74'
AND (
token = 'yZmpXACQr40rFo98FB3wab9y05dekTvwMgPZ3/0YaiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)