UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KPHW4X2vuVx/8AeIBD1MqZfAkble2udtNvEfSeq+HPs='
WHERE
key_id = '948826e9c0cedeb1159e2257b8702046075cf62bec76a487ea990f3279a4d460'
AND (
token = 'KPHW4X2vuVx/8AeIBD1MqZfAkble2udtNvEfSeq+HPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)