UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vtvkXMMaUrkChJ99Kjcj3/0lRo/C3iGtPhXLrKv8o4='
WHERE
key_id = '87a6eb52cf13b12460664d130636182b12982766c6f45455e2d6f66e7a0e0c17'
AND (
token = '6vtvkXMMaUrkChJ99Kjcj3/0lRo/C3iGtPhXLrKv8o4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)