UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ns78i4TMHOAUZm5vaAAs8O5HPDqcSv3eiOMHI7WiEgE='
WHERE
key_id = '6aa471357bf194cde08d3dad310a30989fcba2780d1caebcde7a29e2bd196aeb'
AND (
token = 'Ns78i4TMHOAUZm5vaAAs8O5HPDqcSv3eiOMHI7WiEgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)