UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/AuJKZeZjmU3KTiGy4GxwykIzfLryea1AWyM9mCtMtw='
WHERE
key_id = '9c6fb80591715a1595301248b3f22e042ef314d398c2d4d948b307573ead3651'
AND (
token = '/AuJKZeZjmU3KTiGy4GxwykIzfLryea1AWyM9mCtMtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)