UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TE9ygTKTZWKozD6eoYbM+kri0sz1BtGcwX79mHjVSS4='
WHERE
key_id = 'bcf2c8e072954540d2373a1a42131b1ee4c69c8d7f803498ade6bb94b3440845'
AND (
token = 'TE9ygTKTZWKozD6eoYbM+kri0sz1BtGcwX79mHjVSS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)