UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V7E5bKWrsx5mx4Av9kp7Voz6WZiijsYinSNK0M984SE='
WHERE
key_id = 'fba5f5fe4e9af0f8716aae3bca26a87478e3be289572e0ef71336440fd7f5b3b'
AND (
token = 'V7E5bKWrsx5mx4Av9kp7Voz6WZiijsYinSNK0M984SE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)