UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/gBnX9Wo2oQH2AYXMW9KYb1KhGt4M4O5FlThtXxocrM='
WHERE
key_id = '3b4320f1f84905aac2912ac6984050bf08f8f26c2687855f4f97130c2d8c9788'
AND (
token = '/gBnX9Wo2oQH2AYXMW9KYb1KhGt4M4O5FlThtXxocrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)