UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3vFkV0/KoeHsyYqs7FLahDqMwjI+Y/+dowq+PQk13M0='
WHERE
key_id = 'db89c07dc02dbe73d728ef139ff2577240e3912f358a6be297db5c0c5381a9c7'
AND (
token = '3vFkV0/KoeHsyYqs7FLahDqMwjI+Y/+dowq+PQk13M0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)