UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qWMMqHW9Zw5njnIjyNULZfoBmWp9kChaGcctgJaVOqw='
WHERE
key_id = 'b6041284249177767c157cf1bc33181194508ba3c643f6ca5555fbabab2815fe'
AND (
token = 'qWMMqHW9Zw5njnIjyNULZfoBmWp9kChaGcctgJaVOqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)