UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQZD51PQno7D7cGvfdoSrdsZ2JpZGlbnQyU/3YDnaU4='
WHERE
key_id = '896f9d3205d56e2d48a16abe06bba0a034f954baed34731cc4d818e63d9e6558'
AND (
token = 'gQZD51PQno7D7cGvfdoSrdsZ2JpZGlbnQyU/3YDnaU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)